package org.lb.MarketingSystem.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.lb.MarketingSystem.entity.CustomerUser;
import org.springframework.stereotype.Repository;

@Repository(value="customerUserMapperDao")
public interface CustomerUserMapperDao {
	public List<CustomerUser> select_AllCustomerUsers();    //得到所有客户信息
	public boolean updateCustomerUser(CustomerUser customerUser); //修改客户信息
	public boolean insertCustomerUser(CustomerUser customerUser);   //添加客户
	public boolean dropCustomerUser(Integer customerUserId);  //删除客户
	public CustomerUser selectCustomerUser(@Param("account") String account,
			@Param("password") String password);  //根据账号密码得到用户信息
	public CustomerUser selectCustomerUserById(Integer customerUserId);  //根据用户ID查询用户信息	
	
	
	
	public List<CustomerUser>  selectCustomerUsersByName(@Param("name")String name,@Param("pagenum")Integer pagenum,@Param("number")Integer number);  //根据客户名查询number条数据
	public CustomerUser  selectCustomerUserByAcc(String account); //根据客户账号查询信息	
	public List<CustomerUser> selectCustomeruserByPage(@Param("pagenum")Integer pagenum,@Param("number")Integer number); //根据页数查询number条数据
	public CustomerUser selectCustomerUserByAccAndName(@Param("account") String account,@Param("name")String name);  //根据账号，姓名查询用户信息
	public Integer selectCounts();  //查询客户所有条数
	
	public CustomerUser selectConstomerUserByName(Map<String, Object> map);//根据客户名得到客户信息
	public CustomerUser selectCustomerUserByName(String name);  //根据用户名字查询用户信息
}
